In the form wizard dialog box the fields from the selected table are displayed in this list box.
1.All fields
2.All records
3.Available records
4.Available fields
In the form wizard dialog box the fields from the selected table are displayed in this list box.
1.All fields
2.All records
3.Available records
4.Available fields
It is a query that when run displays its own dialog box prompting you for information such as
1.Select
2.Crosstab
3.Parameter
4.Append
Saving a database in access is done
1. At the beginning of the database
2.The first time you save data
3.When closing the application
4.During auto save
This is not one of the sections of the form design window
1.Form footer
2. Form content
3.Form header
4.Form detail
To set a password for the database select ____________ in the Microsoft Access open window.
1. Open read only
2. Open write only
3.Open explicit
4.Open exclusive
Which of the following database object is created first before any other created?
1.Table
2.Form
3.Report
4.Query
Which of the following is not one of the methods available in the new query dialog box to create queries?
1.Design view
2. Crosstab query wizard
3.Simple query wizard
4.Datasheet view
A collection of related records in database is known as a
1.Table
2.Database
3.File
4. None of above
A part of database that stores complete information about an entity such as employee sales orders etc.
1.File
2.Record
3.Field
4.Query
A query that uses information from two or more tables to get the results is called a(n)
1.Informal query.
2.Optional query.
3.Complex query.
4.Multitable query.
A(n) _____ is an association that is created in a query between a field in one table or query and a field of the same data type in another table or query.
1.Join
2.Link
3.Connector
4.Identifier
Changing the order of this in the query datasheet does not affect the field order in the table.
1.Record
2.Row
3.Column
4.Sort
Database access levels are specified so as to define who can access what in a database. It is identified through
1.User id
2.Password
3.Status
4. None of above
If you make an invalid entry in the input mask wizard dialog box this will display to advise you that the entry is not correct
1.Text error
2.Validation error
3. Literal error
4.Entry error
If you write “Like Su*†in criteria cell of FirstName field it will display
1.All the names that are like Su such as Bunu Kunal Purna
2.All the names that begin with Su such as Suresh Sunita Sumit
3.Blank recordset
4.Error message
In a query when you have multiple conditions and each of them must satisfy to return the result use
1.AND
2.OR
3.NOT
4.XOR
In access this displays the results of a calculation in a query
1.Lookup field
2. Calculated field
3. Source field
4.Child field
In access this operation copies a backup file from the storage medium back onto the computer
1.Recreate
2.Restore
3.Copy
4.Structure
In access this view is used to create and modify the structure of a form.
1.Normal
2.Datasheet
3. Form design
4.Control
In MS Access query which of the fields is derived field? Query: SELECT product.qty AS Quantity product.rate AS Rate product.qty*product.rate AS Amount FROM product
1. Quantity
2.Rate
3.Amount
4.Product
In the second subform wizard dialog box you specify the table to use as the data source and the.
1.Records from the selected form
2.Form from the selected table
3. Fields from the selected table
4.Content from the selected form
In this form a single record may appear in multiple rows in the form window in order to fully display the field name label and data.
1.Datasheet
2.Tabular
3.Justified
4.Columnar
It is a sign or symbol that specifies operator and values that produce a result
1.Operator
2.Query
3.Expression
4.None of the above
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum
1.Parameter
2.Select
3.Crosstab
4.Append
 Which statement does not hold true?
1.A relationship establishes the association between common fields in two tables.
2.An AutoNumber field can be related to a field of either type AutoNumber or type Text.
3.Joins specify that each pair of rows that satisfy the join conditions will be combined in the results to form a single row.
4.Access will automatically create a join only if the field names in both tables are the same.
Microsoft Access uses Jet Query Engine which uses
1.MS SQL Server
2.Full fledged SQL
3.Dialect of SQL
4.None of above
Queries are based on this allowing you to use a query as the source for forms and reports
1.Filters
2.Tables
3.Records
4.Fields
Some rules are set in databases to check and permit only correct values. What is this feature called?
1.Data verification
2.Auditing
3.Data filtering
4. Data validation
The ascending order of data hierarchy is?
1.Bit – byte – field – record – file – databse
2.Bit – byte – record – field – file – database
3.Byte – bit – field – record – file – database
4.Bit – byte – field – record – database – file
The ‘filter by selection’ allows you to filter those records
1.That match the selected field
2.That match the criteria specified
3.That meet any of several criteria specified
4. All of above
The operation of checking input data against specified criteria is known as?
1.Data verification
2. Data validation
3.Cross check
4.Data control
The quickest way to add a field to the selected fields list is to double-click its field name in this list.
1.Find fields
2.Search fields
3. Search record
4.Available fields
The result of a query is displayed in a
1.Record
2. Query datasheet
3.Query table
4.Forms
This form displays multiple records one per row in the form window
1.Datasheet
2.Tabular
3.Columnar
4.Justified
This form displays the field name labels down the left side of the column with the data for each field just to the right of its corresponding label.
1.Tabular
2.Justified
3.Columnar
4.Datasheet
This query wizard will create a select query.
1.Crosstab
2.Find duplicates
3.Simple
4.Design view
This type of database contains multiple tables that are connected to produce combined output from all tables.
1.Bound
2.Linked
3.Relational
4.Joined
This type of query summarizes large amounts of data in easy-to-read row-and-column format.
1.Crosstab
2.Columnar
3.Select
4.Action
To create this you enter an expression in the design grid that instructs access to perform a calculation using the current field values.
1.Formulated field
2. Numeric field
3. Formula field
4.Calculated field
To enter the input mask wizard
1.Click on the three dots to the right of the caption entry field
2.Click on the three dots to the right of the format entry field
3.Click on the input mask toolbar
4.Click on the three dots to the right of the input mask entry field
What it is called to present information in a particular order based on numeric or alphabetical value?
1.Sorting
2.Searching
3. Arranging
4.Cropping
When you need to restrict the records that meets certain conditions you can mention them in
1.Filter cell
2.Sort cell
3.Show cell
4.Criteria cell
When you select this control its associated text control is also selected and the two controls will act as one when manipulated.
1.Text
2.Form
3.Label
4.Field
Which of the following database object can be used if you need to mail the invoice to customers?
1. A form
2.A query
3.A report
4.A table
Which of the following is not a form style available in the form wizard dialog box.
1.Blends
2.Standard
3.Stone
4.Highlights
Which of the following SQL query deletes Product table from Store database?
1.DEL Product FROM Store
2.DROP Product
3. DROP TABLE Product
4.Any of b or c
You can enclose the prompt within square braces in criteria to create
1.Parameter query
2. Select query
3.Action query
4.Crosstab query
You can move between fields in a form by using any of these keys except
1.Tab
2.Enter
3.Shift+tab
4.Page up